<?php 
include ('configuration.php');
	session_start();
	$var1= $_SESSION["registrado"];
	$var2= $_SESSION["administrador"];
	if ($var1 == null): {
		echo ("User not registered");
	} elseif ($var2 == 0): { 
			echo ("User without permissions");
	} else : {
 	
//vinculo los miembros seleccionados al proyecto
    $id_member=$_POST['select_member'];
    $id_pro=$_GET['id_pro'];
	
	foreach ($id_member as $aux_idmember){
	    //creo la relacion entre el miembro y el proyecto
	    mysql_query("INSERT INTO participate (id_project_participate, id_member_participate, is_responsible)
	    VALUES ('$id_pro',$aux_idmember, '0')") or die('Error, query failed');
	}


        ?><script type="text/javascript">
             alert("Members added to project");
          </script>
           


<!doctype html>
<html xmlns:fb="http://www.facebook.com/2008/fbml">

<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">

<link href="css/bootstrap.css" rel="stylesheet" media="screen">
<link href="css/bootstrap-responsive.css" rel="stylesheet"	media="screen">

<title>My project manager</title>

<style type="text/css">
  body {
    padding-top: 60px;
    padding-bottom: 40px;
  }
  .sidebar-nav {
    padding: 9px 0;
  
  }
    .container {
    padding-top: 100px;
  }

    .finish {
        padding-top: 500px;
        padding-left: 25px;
        padding-right: 25px;
  }
  

  
  @media (max-width: 980px) {
    /* Enable use of floated navbar text */
    .navbar-text.pull-right {
      float: none;
      padding-left: 5px;
      padding-right: 5px;
    }
  }
</style>

</head>

<body>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/bootstrap.js"></script>


<div class="navbar navbar-inverse navbar-fixed-top">
	<div class="navbar-inner">
		<div class="container-fluid">
			<button type="button" class="btn btn-navbar" data-toggle="collapse"
				data-target=".nav-collapse">
				<span class="icon-bar"></span> <span class="icon-bar"></span> <span
					class="icon-bar"></span>
			</button>
			<a class="brand" href="http://localhost/bases--grupo10/homeAdmin.php?">My project manager</a>
			<div class="nav-collapse collapse">
				<p class="navbar-text pull-right">
				
					<a href="http://localhost/bases--grupo10/logout.php?" class="navbar-link">Log out</a>
				</p>
				<ul class="nav">
					<li class="active"><a href="http://localhost/bases--grupo10/homeAdmin.php?">Home</a></li>
					<li><a href="http://localhost/bases--grupo10/about.php?">About</a></li>
					<li><a href="http://localhost/bases--grupo10/contact.php?">Contact</a></li>
				</ul>
			</div>
		</div>
	</div>
</div>
	
<div class="span12" >	
    <h1 class="muted" >New project -> Add responsibles</h1>	
    <h3 class="muted" ><font size="5"></font>Push Next if you don´t add responsibles now</h3>
	<h3 class="muted" ><font size="5"></font>You can add responsibles after in modify project</h3>				
</div>
	
	
<div class="span12" >  
    <div class="container-fluid">        					
        <form method="post" action="http://localhost/bases--grupo10/new_project_final.php?id_pro=<?php echo $id_pro?>">	
        	<select name="select_responsible">
        	    <option value="0">Select a member</option>
        	        <?php  
            		$id_pro=$_GET['id_pro'];
                     //consulta para sacar los nombres de los nombres correspondientes a los id que participan en el proyecto
            		$QUERY =  mysql_query ("SELECT id_member, name_member, surnames_member  FROM project_member WHERE id_member in (
                            SELECT id_member_participate FROM participate WHERE id_project_participate ='$id_pro') and mail_member is not null"); 
                   	while ($row =mysql_fetch_array($QUERY))  {  
                       echo "<option value=".$row['id_member'].">".$row['name_member']. " ".$row['surnames_member']."</option>";
                   	}      
                   ?>            
               </select>

               <input class="btn btn-primary" type="submit" name="enviar" value="Add responsibles to project" >
        </form >
    </div>
</div> 
 
<div class="finish">   	
	<a class="btn btn-primary pull-right" type="button" href="http://localhost/bases--grupo10/homeAdmin.php?" >Next</a>  	
</div> 	

</body>
</html>


<?php          
}endif;?>